package ab.mes.mapper;

import ab.mes.entity.Bin;
import ab.mes.entity.BinStock;
import ab.mes.entity.FinishedProductBinStock;
import ab.mes.tools.Result;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BinStockMapper {
    //查询物料库位信息
    @Select("select * from bin_stock")
    List<BinStock> getBinStock();

    //查询库位编号物料库位信息
    @Select("select * from bin_stock where bin_no = #{bin_no}")
    public BinStock getBinStockById(@Param("bin_no") String Id);


    //添加库位信息
    public Result insertBinStock(BinStock binStock);

    //编辑库位
    Result editBinStock(BinStock binStock);

}
